﻿using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class web_pages_ajax_san_ntv_ket_qua_pv : System.Web.UI.Page
{
    DataTable dtt = new DataTable();
    Common comm = new Common();
    public string masan = "";
    public string mantv = "";
    public string mantd = "";
    public string mavlt = "";
   
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["SanNTV"] != null)
            if ((bool)Session["SanNTV"] == true)
            {
                masan = Request.QueryString["masan"];
                mantv = Request.QueryString["mantv"];
                mantd = Request.QueryString["mantd"];
                mavlt = Request.QueryString["mavlt"];

                dtt = comm.getDataTable("Select * from SanGiaoDich_ket_qua_phong_van where ma_san ='"+masan+"' and ma_ntv ='"+mantv+"' and ma_doanh_nghiep = '"+mantd +"' and ma_vlt ='"+mavlt + "'");

                if (dtt.Rows.Count > 0)
                {
                   
                    Label_ketqua.Text = Convert.ToInt32(dtt.Rows[0]["ket_qua"]) == 1 ? "Trúng Tuyển" : "Không trúng tuyển";
                    Label_mota.Text = dtt.Rows[0]["ghi_chu"].ToString();
                    Label_ngay.Text = dtt.Rows[0]["ngay_phong_van"].ToString();
                }
                else {
                   
                }
            }
    }
}
